CREATE DATABASE ReconEngine;

USE ReconEngine;

CREATE TABLE conf_customer_file_format ( customer_id varchar(10) NOT NULL, field_mapping_id varchar(5) NOT NULL, file_type varchar(1) NOT NULL, file_format varchar(5) NOT NULL, separator varchar(1), PRIMARY KEY  (customer_id,field_mapping_id));
INSERT INTO conf_customer_file_format (customer_id,field_mapping_id,file_type,file_format,separator) 
VALUES('001','CUSI1','I','Comma',','), 
('001','CUSS1','S','Comma',',');
CREATE TABLE conf_customer_menu ( customer_id varchar(10) NOT NULL, menu_id varchar(10) NOT NULL, checker_enabled tinyint default 0, PRIMARY KEY  (customer_id,menu_id));
CREATE TABLE conf_file_field_mapping ( field_mapping_id varchar(5) NOT NULL, source_field_index varchar(3) NOT NULL, target_field_index varchar(3) NOT NULL, source_start_index int, source_end_index int);
INSERT INTO conf_file_field_mapping (field_mapping_id,source_field_index,target_field_index,source_start_index,source_end_index) 
VALUES('CUSI1','2','2',0,0), 
('CUSI1','3','3',0,0), 
('CUSI1','4','4',0,0), 
('CUSI1','5','5',0,0), 
('CUSI1','6','6',0,0), 
('CUSI1','7','7',0,0), 
('CUSI1','8','8',0,0), 
('CUSI1','9','9',0,0), 
('CUSI1','10','10',0,0), 
('CUSI1','11','11',0,0), 
('CUSI1','12','12',0,0), 
('CUSI1','13','13',0,0), 
('CUSI1','14','14',0,0), 
('CUSI1','18','18',0,0), 
('CUSI1','15','15',0,0), 
('CUSI1','16','16',0,0), 
('CUSI1','17','17',0,0), 
('CUSS1','3','3',0,0), 
('CUSS1','2','2',0,0), 
('CUSS1','4','4',0,0), 
('CUSS1','5','5',0,0), 
('CUSS1','6','6',0,0), 
('CUSS1','7','7',0,0), 
('CUSS1','8','8',0,0), 
('CUSS1','9','9',0,0), 
('CUSS1','10','10',0,0), 
('CUSS1','11','11',0,0), 
('CUSS1','12','12',0,0), 
('CUSS1','13','13',0,0), 
('CUSS1','14','14',0,0), 
('CUSS1','15','15',0,0), 
('CUSS1','16','16',0,0);
CREATE TABLE conf_menu_maint ( menu_id varchar(5) NOT NULL, menu_type varchar(5) NOT NULL, menu_name varchar(50) NOT NULL, menu_link varchar(150), menu_order tinyint NOT NULL, parent_id varchar(5), parent_order tinyint NOT NULL, is_nonmenu tinyint NOT NULL default 0, is_enabled tinyint NOT NULL default 1, PRIMARY KEY  (menu_id));
INSERT INTO conf_menu_maint (menu_id,menu_type,menu_name,menu_link,menu_order,parent_id,parent_order,is_nonmenu,is_enabled) 
VALUES('1','Cust','Home','ReconHome.aspx',1,'0',0,0,1), 
('2','Cust','File Upload','FileUpload.aspx',2,'0',0,0,1), 
('3','Cust','Matching Screen','MatchInvoice.aspx',3,'0',0,0,1), 
('4','Cust','Invoice/Credit Note','InvoiceCreditNote.aspx',4,'0',0,0,1), 
('5','Cust','Admin','',5,'0',0,0,1), 
('6','Cust','User Maintenance','UserMaster.aspx',0,'5',1,0,1), 
('7','Cust','Customer Maintenance','CustomerMaster.aspx',0,'5',2,0,1), 
('8','Cust','Remitter Maintenance','RemitterMaster.aspx',0,'5',3,0,1), 
('9','Remit','Invoice Entry',NULL,6,NULL,0,0,1);
CREATE TABLE mast_bank_maint ( bank_id varchar(10) NOT NULL, bank_name varchar(35), bank_ifsc varchar(11) NOT NULL, bank_bic varchar(11), bank_branch varchar(50) NOT NULL, bank_address1 varchar(50) NOT NULL, bank_address2 varchar(50), bank_address3 varchar(50), bank_city varchar(35) NOT NULL, bank_state varchar(35) NOT NULL, bank_country varchar(35) NOT NULL, bank_zipcode varchar(10) NOT NULL, bank_telno varchar(15) NOT NULL, bank_email_id varchar(100) NOT NULL, is_enabled bit NOT NULL, entered_id varchar(10), entered_date datetime, modified_id varchar(10), modified_date datetime, PRIMARY KEY  (bank_id));
CREATE TABLE mast_communication_maint ( customer_id varchar(10) NOT NULL, is_mailenabled bit NOT NULL, is_mobileenabled bit NOT NULL, mobile_no varchar(15) NOT NULL, email_id varchar(50) NOT NULL, recipient_type bit NOT NULL, is_enabled varchar(5) NOT NULL, PRIMARY KEY  (customer_id));
CREATE TABLE mast_customer_account_maint ( customer_id varchar(10) NOT NULL, account_number varchar(20) NOT NULL, account_name varchar(50), bank_id varchar(10), PRIMARY KEY  (customer_id));
CREATE TABLE mast_customer_maint ( customer_id varchar(10) NOT NULL, customer_name varchar(100) NOT NULL, customer_address1 varchar(50), customer_address2 varchar(50), customer_city varchar(35), customer_state varchar(35), customer_country varchar(35), customer_zipcode varchar(10), customer_telno varchar(15), customer_emailid varchar(100), is_fileencryptenabled bit, is_pgpenabled tinyint default 1, is_active tinyint default 1, is_enabled tinyint NOT NULL default 1, addby_id varchar(10) NOT NULL, addby_datetime datetime NOT NULL, modby_id varchar(10), modby_datetime datetime, authby_id varchar(10), authby_datetime datetime, is_remitter_availble tinyint, bank_id varchar(10), is_remittercode_avaiable tinyint, is_autoreconciliation tinyint, PRIMARY KEY  (customer_id));
INSERT INTO mast_customer_maint (customer_id,customer_name,customer_address1,customer_address2,customer_city,customer_state,customer_country,customer_zipcode,customer_telno,customer_emailid,is_fileencryptenabled,is_pgpenabled,is_active,is_enabled,addby_id,addby_datetime,modby_id,modby_datetime,authby_id,authby_datetime,is_remitter_availble,bank_id,is_remittercode_avaiable,is_autoreconciliation) 
VALUES('001','Ramkumar','mumbai','mumbai','mumbai','mumbai','mumbai','99999','99999','ramkumer@gmail.com',NULL,1,1,1,'user1','2013-07-20 00:00:00','user1','2013-07-20 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL), 
('0704004104','kuntal','dhd','dhd','dhd','guj','ind','389','730','kun@cm.com',NULL,NULL,1,1,'Kuntal','2013-07-04 00:00:00','Kuntal','2013-07-04 00:00:00','Kuntal','2013-07-04 00:00:00',NULL,NULL,NULL,NULL), 
('0711004844','guru','guru','guru','guru','guru','guru','777777','9876543210','guru@guru.guru',NULL,1,1,1,'user1','2013-07-11 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('0711004933','kuntals','kuntal','kuntal','kuntal','kuntal','kuntal','','','',NULL,1,1,1,'user1','2013-07-11 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('0711005345','       hgsd    ','          kdkfdk       ','                dfkdfd ','                dfkdkf','kfkgf','                 kfkkj     ','          ','               ','                        ',NULL,1,1,1,'user1','2013-07-11 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('0711010002','fdfd','dfffffffffffff','ff','fff','ff','fdf','','','',NULL,1,1,1,'user1','2013-07-11 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('cust1','radhe','radhe','radhe','Mum','Maha','India','123456','987654321','radhe@radhe.com',NULL,NULL,1,1,'Kuntal','2013-06-15 00:00:00','user1','2013-07-17 00:00:00','Kuntal','2013-06-15 00:00:00',NULL,NULL,NULL,NULL), 
('cust2','kuntal','radhe','radhe','Mum','Maha','India','123456','98765432100','radhe@radhe.com',NULL,1,1,1,'user1','2013-07-17 00:00:00','user1','2013-07-17 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL);
CREATE TABLE mast_discount_maint ( customer_id varchar(10) NOT NULL, discount_code varchar(5) NOT NULL, effective_date datetime NOT NULL, days_start int, days_end int, discount_percentage float, min_amount float, max_amount float, PRIMARY KEY  (customer_id,discount_code));
INSERT INTO mast_discount_maint (customer_id,discount_code,effective_date,days_start,days_end,discount_percentage,min_amount,max_amount) 
VALUES('001','D0001','2013-07-20 20:10:54',1,30,3,NULL,NULL);
CREATE TABLE mast_panalty_maint ( customer_id varchar(10) NOT NULL, panalty_code varchar(5) NOT NULL, effective_date datetime NOT NULL, days_start int, days_end int, panalty_percentage float, min_amount float, max_amount float, PRIMARY KEY  (customer_id,panalty_code));
INSERT INTO mast_panalty_maint (customer_id,panalty_code,effective_date,days_start,days_end,panalty_percentage,min_amount,max_amount) 
VALUES('001','P0001','2013-07-20 12:54:30',1,30,4,NULL,NULL);
CREATE TABLE mast_remitter_account_maint ( remitter_id varchar(10) NOT NULL, account_number varchar(20) NOT NULL, account_name varchar(50), bank_id varchar(10), PRIMARY KEY  (remitter_id));
CREATE TABLE mast_remitter_maint ( remitter_id varchar(10) NOT NULL, remitter_name varchar(100) NOT NULL, discount_code varchar(5), penalty_code varchar(5), customer_id varchar(10) NOT NULL, address1 varchar(50) NOT NULL, address2 varchar(50), address3 varchar(50), city varchar(35), state varchar(35), country varchar(35), zipcode varchar(10), tel_no varchar(15), email_id varchar(100), is_active tinyint default 1, is_enable tinyint, addby_id varchar(10) NOT NULL, addby_datetime datetime NOT NULL, modby_id varchar(10), modby_datetime datetime, authby_id varchar(10), authby_datetime datetime, PRIMARY KEY  (remitter_id));
INSERT INTO mast_remitter_maint (remitter_id,remitter_name,discount_code,penalty_code,customer_id,address1,address2,address3,city,state,country,zipcode,tel_no,email_id,is_active,is_enable,addby_id,addby_datetime,modby_id,modby_datetime,authby_id,authby_datetime) 
VALUES('0706144532','guru','D0001','P0001','001','guru','guru','guru','guru','guru','guru','987654','987654321','guru@guru.guru',1,1,'Kuntal','2013-07-06 00:00:00','Kuntal','2013-07-06 00:00:00','Kuntal','2013-07-06 00:00:00'), 
('R01','kuntal','D0001','P0001','001','mumbai','mum','mumbai','mum','mah','india','123456','9876543210','kun@w.c',1,1,'user1','2013-07-17 00:00:00',NULL,NULL,NULL,NULL), 
('R02','kuntal','D0001','P0001','001','mumbai','mum','mumbai','mum','mah','india','123456','9876543210','kun@w.c',1,1,'user1','2013-07-17 00:00:00','user1','2013-07-17 00:00:00',NULL,NULL), 
('R03','Radhe','D0001','P0001','001','Radhe','Rahde','Rahde','','','','111','2222222','Rahde@gmail.com',1,1,'Kuntal','2013-06-21 00:00:00','Kuntal','2013-06-21 00:00:00','Kuntal','2013-06-21 00:00:00'), 
('R04','Radhe',NULL,NULL,'001','Radhe','Rahde','Rahde','Rahde','Rahde','Rahde','111','2222222','Rahde@gmail.com',1,1,'user1','2013-07-20 00:00:00',NULL,NULL,NULL,NULL);
CREATE TABLE mast_role_maint ( role_id varchar(10) NOT NULL, role_code varchar(4) NOT NULL, role_desc varchar(50) NOT NULL, role_type varchar(5) NOT NULL, is_enabled tinyint NOT NULL default 0, entered_id varchar(10) NOT NULL, entered_date datetime, modified_date datetime, modified_id varchar(10), access_rights int, PRIMARY KEY  (role_id));
INSERT INTO mast_role_maint (role_id,role_code,role_desc,role_type,is_enabled,entered_id,entered_date,modified_date,modified_id,access_rights) 
VALUES('Customer','cust','Customer','C',1,'Kuntal','2013-06-30 21:19:08',NULL,NULL,1), 
('Remitter','remi','Remitter','R',1,'Kuntal','2013-06-30 21:21:06',NULL,NULL,1), 
('System','syst','System','S',1,'Kuntal','2013-06-30 21:21:14',NULL,NULL,1);
CREATE TABLE mast_role_menu_maint ( role_id varchar(10) NOT NULL, menu_id varchar(10) NOT NULL, is_enabled tinyint NOT NULL default 1, entered_id varchar(10), entered_date datetime, modified_id varchar(10), modified_date datetime, PRIMARY KEY  (role_id,menu_id));
INSERT INTO mast_role_menu_maint (role_id,menu_id,is_enabled,entered_id,entered_date,modified_id,modified_date) 
VALUES('Customer','1',1,'user1','2013-07-08 00:00:00','user1',NULL), 
('Customer','2',1,'user1','2013-07-08 17:26:58','user1','2013-07-08 17:26:58'), 
('Customer','3',1,'user1','2013-07-08 17:27:05','user1','2013-07-08 17:27:05'), 
('Customer','4',1,'user1','2013-07-08 17:27:13','user1','2013-07-08 17:27:13'), 
('Customer','5',1,'user1','2013-07-08 17:27:42','user1','2013-07-08 17:27:42'), 
('Customer','6',1,'user1','2013-07-08 17:28:09','user1','2013-07-08 17:28:09'), 
('Customer','7',1,'user1','2013-07-08 17:28:18','user1','2013-07-08 17:28:18'), 
('Customer','8',1,'user1','2013-07-08 17:28:25','user1','2013-07-08 17:28:25'), 
('Remitter','1',1,'user1',NULL,NULL,NULL), 
('Remitter','5',1,'kuntal1','2013-07-20 21:09:49','user1','2013-07-20 21:09:49'), 
('Remitter','8',1,'kuntal1','2013-07-20 21:07:07','user1','2013-07-20 21:07:07');
CREATE TABLE mast_user_maint ( User_Id varchar(10) NOT NULL, User_Type varchar(5) NOT NULL, Remitter_Id varchar(10), Customer_Id varchar(10) NOT NULL, User_Name varchar(35), User_Password varchar(50) NOT NULL, Role_Id varchar(10) NOT NULL, Is_MailEnabled bit, Is_MobileEnabled bit, Email_Id varchar(50), Mobile_No varchar(15), Is_Enabled tinyint NOT NULL, Is_LoggedIn tinyint NOT NULL, Is_Locked tinyint NOT NULL, Is_Active tinyint NOT NULL, Login_Attempt tinyint NOT NULL, LatLogin_DateTime datetime, Password_ExpiryDate datetime, AddBy_UserId varchar(10), AddBy_Date datetime, ModBy_UserId varchar(10), ModBy_Date datetime, AuthBy_UserId varchar(10), AuthBy_Date datetime, CurrentLogin_Datetime datetime, Is_DomainUser tinyint, PRIMARY KEY  (User_Id));
INSERT INTO mast_user_maint (User_Id,User_Type,Remitter_Id,Customer_Id,User_Name,User_Password,Role_Id,Is_MailEnabled,Is_MobileEnabled,Email_Id,Mobile_No,Is_Enabled,Is_LoggedIn,Is_Locked,Is_Active,Login_Attempt,LatLogin_DateTime,Password_ExpiryDate,AddBy_UserId,AddBy_Date,ModBy_UserId,ModBy_Date,AuthBy_UserId,AuthBy_Date,CurrentLogin_Datetime,Is_DomainUser) 
VALUES('kuntal1','R','rem2','003','kuntal','Password12','Remitter',NULL,NULL,'kuntal@gmail.com','9876543210',1,0,0,1,0,'2013-07-08 00:00:00','2013-10-06 00:00:00','user1','2013-07-08 00:00:00',NULL,NULL,NULL,NULL,'2013-07-08 00:00:00',1), 
('RamKumar','S','r01','001','ram kumar','','System',NULL,NULL,'ramkumar@gmail.com','9876543220',1,0,0,1,0,'2013-07-20 00:00:00','2013-10-18 00:00:00','user1','2013-07-20 00:00:00','user1','2013-07-20 00:00:00',NULL,NULL,'2013-07-20 00:00:00',0), 
('user1','cust','rem1','001','username','Password12','Customer',NULL,NULL,'kuntal@gmail.com','9876543210',1,0,0,1,0,'2013-07-02 00:00:00','2013-09-30 00:00:00','Kuntal','2013-07-02 00:00:00',NULL,NULL,NULL,NULL,'2013-07-02 00:00:00',1), 
('user2','cust','rem2','002','radhe','Radhe123','Customer',NULL,NULL,'radhe@gmail.com','9876543210',1,0,0,1,0,'2013-07-06 00:00:00','2013-10-04 00:00:00','Kuntal','2013-07-06 00:00:00',NULL,NULL,NULL,NULL,'2013-07-06 00:00:00',1), 
('user3','S','','004','kuntal','Password12','System',NULL,NULL,'abc@abc.com','9876543210',1,0,0,1,0,'2013-07-14 00:00:00','2013-10-12 00:00:00','user1','2013-07-14 00:00:00',NULL,NULL,NULL,NULL,'2013-07-14 00:00:00',1), 
('yogesh2','C','rem5','001','yogesh','Password12','Customer',NULL,NULL,'kuntal@12.com','9876543210',1,0,0,1,0,'2013-07-20 00:00:00','2013-10-18 00:00:00','user1','2013-07-16 00:00:00','user1','2013-07-20 00:00:00',NULL,NULL,'2013-07-20 00:00:00',0), 
('yogwsh1','C','rem4','001','yoges','Password12','Customer',NULL,NULL,'yogesh@gmail.com','9876543210',1,0,0,1,0,'2013-07-16 00:00:00','2013-10-14 00:00:00','user1','2013-07-16 00:00:00',NULL,NULL,NULL,NULL,'2013-07-16 00:00:00',0);
CREATE TABLE pro_file_staging ( file_id int NOT NULL, field1 varchar(250) NOT NULL, field2 varchar(250) NOT NULL, field3 varchar(250), field4 varchar(250), field5 varchar(250), field6 varchar(250), field7 varchar(250), field8 varchar(250), field9 varchar(250), field10 varchar(250), field11 varchar(250), field12 varchar(250), field13 varchar(250), field14 varchar(250), field15 varchar(250), field16 varchar(250), field17 varchar(250), field18 varchar(250), field19 varchar(250), field20 varchar(250), field21 varchar(250), field22 varchar(250), field23 varchar(250), field24 varchar(250), field25 varchar(250), field26 varchar(250), field27 varchar(250), field28 varchar(250), field29 varchar(250), field30 varchar(250), field31 varchar(250), field32 varchar(250), field33 varchar(250), field34 varchar(250), field35 varchar(250), field36 varchar(250), field37 varchar(250), field38 varchar(250), field39 varchar(250), field40 varchar(250), field41 varchar(250), field42 varchar(250), field43 varchar(250), field44 varchar(250), field45 varchar(250), field46 varchar(250), field47 varchar(250), field48 varchar(250), field49 varchar(250), field50 varchar(250), field51 varchar(250), field52 varchar(250), field53 varchar(250), field54 varchar(250), field55 varchar(250), field56 varchar(250), field57 varchar(250), field58 varchar(250), field59 varchar(250), field60 varchar(250), field61 varchar(250), field62 varchar(250), field63 varchar(250), field64 varchar(250), field65 varchar(250), field66 varchar(250), field67 varchar(250), field68 varchar(250), field69 varchar(250), field70 varchar(250), field71 varchar(250), field72 varchar(250), field73 varchar(250), field74 varchar(250), field75 varchar(250), field76 varchar(250), field77 varchar(250), field78 varchar(250), field79 varchar(250), field80 varchar(250), field81 varchar(250), field82 varchar(250), field83 varchar(250), field84 varchar(250), field85 varchar(250), field86 varchar(250), field87 varchar(250), field88 varchar(250), field89 varchar(250), field90 varchar(250), field91 varchar(250), field92 varchar(250), field93 varchar(250), field94 varchar(250), field95 varchar(250), field96 varchar(250), field97 varchar(250), field98 varchar(250), field99 varchar(250), field100 varchar(250));
INSERT INTO pro_file_staging (file_id,field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12,field13,field14,field15,field16,field17,field18,field19,field20,field21,field22,field23,field24,field25,field26,field27,field28,field29,field30,field31,field32,field33,field34,field35,field36,field37,field38,field39,field40,field41,field42,field43,field44,field45,field46,field47,field48,field49,field50,field51,field52,field53,field54,field55,field56,field57,field58,field59,field60,field61,field62,field63,field64,field65,field66,field67,field68,field69,field70,field71,field72,field73,field74,field75,field76,field77,field78,field79,field80,field81,field82,field83,field84,field85,field86,field87,field88,field89,field90,field91,field92,field93,field94,field95,field96,field97,field98,field99,field100) 
VALUES(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
(12,'1111111111','bbbbbbbbbbbbbbb','2222222222222222','cccccccccccccc','333333333333333333','dddddddddddd','444444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
CREATE TABLE pro_file_upload_details ( customer_id varchar(10) NOT NULL, file_id varchar(20) NOT NULL, file_name varchar(35) NOT NULL, file_type varchar(10) NOT NULL, file_upload_date datetime NOT NULL, file_upload_by varchar(10) NOT NULL, file_auth_date datetime, file_auth_by varchar(10), file_status varchar(5) NOT NULL, error_desc varchar(100), row_count int default '0', file_amount int default '0', PRIMARY KEY  (file_id,customer_id));
INSERT INTO pro_file_upload_details (customer_id,file_id,file_name,file_type,file_upload_date,file_upload_by,file_auth_date,file_auth_by,file_status,error_desc,row_count,file_amount) 
VALUES('001','210713112840','TestInvoiceFile.txt','I','2013-07-21 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','210713112902','TestStatement.txt','S','2013-07-21 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713222816','TestSInvoice_1.txt','I','2013-07-23 00:00:00','user1',NULL,NULL,'N','null',0,0), 
('001','230713222829','TestStatement_1 (2).txt','S','2013-07-23 00:00:00','user1',NULL,NULL,'N','null',0,0), 
('001','230713222835','TestSInvoice_1.txt','S','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713222844','TestStatement_1 (2).txt','I','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713223116','TestStatement_5.txt','I','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713223126','TestSInvoice_3.txt','S','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713224028','TestStatement_7.txt','I','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0), 
('001','230713224036','TestSInvoice_5.txt','S','2013-07-23 00:00:00','user1',NULL,NULL,'UPLOD','null',4,0);
CREATE TABLE pro_invoice ( invoice_unique_id int identity(1,1), remitter_id varchar(10), customer_id varchar(10) NOT NULL, invoice_number varchar(20) NOT NULL, date datetime NOT NULL, currency varchar(3) NOT NULL, amount float NOT NULL, po_ref varchar(20) NOT NULL, service_tax int NOT NULL, vat int NOT NULL, cess int NOT NULL, sales_tax int NOT NULL, tax1 int NOT NULL, tax2 int NOT NULL, tax3 int NOT NULL, discount int NOT NULL, invoic_status char(1) NOT NULL, is_partial tinyint default 1, PRIMARY KEY  (invoice_unique_id));
INSERT INTO pro_invoice (remitter_id,customer_id,invoice_number,date,currency,amount,po_ref,service_tax,vat,cess,sales_tax,tax1,tax2,tax3,discount,invoic_status,is_partial) 
VALUES('R01','001','inv1','2013-07-07 00:00:00','INR','2000000','PR1',20000,4000,120,20000,0,0,0,0,'M',0), 
('R03','001','inv2','2013-07-07 00:00:00','INR','52000','PR2',0,0,0,0,0,0,0,0,'N',0), 
('R02','001','inv3','2013-07-07 00:00:00','INR','13000000','PR1',13200,1300,130,1300,0,0,0,0,'D',0), 
('R01','001','inv4','2013-07-07 00:00:00','INR','150000','PR1',0,0,0,0,0,0,0,0,'N',0), 
('R01','001','inv1','2013-07-07 00:00:00','INR','2000000','PR1',20000,4000,120,20000,0,0,0,0,'N',0), 
('R03','001','inv2','2013-07-07 00:00:00','INR','52000','PR2',0,0,0,0,0,0,0,0,'N',0), 
('R02','001','inv3','2013-07-07 00:00:00','INR','13000000','PR1',13200,1300,130,1300,0,0,0,0,'N',0), 
('R01','001','inv4','2013-07-07 00:00:00','INR','150000','PR1',0,0,0,0,0,0,0,0,'N',0), 
('R01','001','inv1','2013-07-07 00:00:00','INR','2000000','PR1',20000,4000,120,20000,0,0,0,0,'N',0), 
('R03','001','inv2','2013-07-07 00:00:00','INR','52000','PR2',0,0,0,0,0,0,0,0,'N',0), 
('R02','001','inv3','2013-07-07 00:00:00','INR','13000000','PR1',13200,1300,130,1300,0,0,0,0,'N',0),
('R01','001','inv4','2013-07-07 00:00:00','INR','150000','PR1',0,0,0,0,0,0,0,0,'N',0), 
('R01','001','inv1','2013-07-07 00:00:00','INR','2000000','PR1',20000,4000,120,20000,0,0,0,0,'N',0), 
('R03','001','inv2','2013-07-07 00:00:00','INR','52000','PR2',0,0,0,0,0,0,0,0,'N',0), 
('R02','001','inv3','2013-07-07 00:00:00','INR','13000000','PR1',13200,1300,130,1300,0,0,0,0,'N',0), 
('R01','001','inv4','2013-07-07 00:00:00','INR','150000','PR1',0,0,0,0,0,0,0,0,'N',0);
CREATE TABLE pro_invoice_dump ( remitter_id varchar(10) NOT NULL, customer_id varchar(10) NOT NULL, file_id int NOT NULL, billing_company_name varchar(20) NOT NULL, billing_company_address1 varchar(45) NOT NULL, billing_company_address2 varchar(45) NOT NULL, billing_company_address3 varchar(45) NOT NULL, billing_company_address4 varchar(45) NOT NULL, billing_company_city varchar(45) NOT NULL, billing_company_country varchar(45) NOT NULL, billing_phone1 varchar(45) NOT NULL, billing_phone2 varchar(45) NOT NULL, billing_fax varchar(45) NOT NULL, customer_name varchar(45) NOT NULL, customer_billing_address1 varchar(45) NOT NULL, customer_billing_address2 varchar(45) NOT NULL, customer_billing_address3 varchar(45) NOT NULL, customer_billing_address4 varchar(45) NOT NULL, customer_billing_city varchar(45) NOT NULL, customer_billing_pincode varchar(45) NOT NULL, customer_country varchar(45) NOT NULL, customer_billing_contact_name varchar(45) NOT NULL, customer_billing_contact_name_phone varchar(45) NOT NULL, customer_shipping_address1 varchar(45) NOT NULL, customer_shipping_address2 varchar(45) NOT NULL, customer_shipping_address3 varchar(45) NOT NULL, customer_shipping_city varchar(45) NOT NULL, customer_shipping_pincode varchar(45) NOT NULL, customer_shipping_contact_name varchar(45) NOT NULL, customer_shipping_customer_phone varchar(45) NOT NULL, sub_customer_name varchar(45) NOT NULL, sub_customer_code varchar(45) NOT NULL, sub_customer_address1 varchar(45) NOT NULL, sub_customer_address2 varchar(45) NOT NULL, sub_customer_address3 varchar(45) NOT NULL, sub_customer_address4 varchar(45) NOT NULL, sub_customer_phone varchar(45) NOT NULL, sub_customer_city varchar(45) NOT NULL, sub_customer_pincode varchar(45) NOT NULL, invoice_number varchar(45) NOT NULL, invoice_date varchar(45) NOT NULL, customer_ref_number varchar(45) NOT NULL, comments varchar(45) NOT NULL, sales_person_name varchar(45) NOT NULL, purchase_order_number varchar(45) NOT NULL, purchase_order_date varchar(45) NOT NULL, requisitioner varchar(45) NOT NULL, ship_via varchar(45) NOT NULL, fob_point varchar(45) NOT NULL, terms varchar(45) NOT NULL, product_quantity varchar(45) NOT NULL, product_desc varchar(45) NOT NULL, product_code varchar(45) NOT NULL, product_unit_price varchar(45) NOT NULL, product_invoice_currency varchar(45) NOT NULL, product_total varchar(45) NOT NULL, product_subtotal varchar(45) NOT NULL, sales_tax varchar(45) NOT NULL, shipping_handling_charge varchar(45) NOT NULL, vat varchar(45) NOT NULL, gst varchar(45) NOT NULL, local_body_tax varchar(45) NOT NULL, service_tax varchar(45) NOT NULL, other_taxes varchar(45) NOT NULL, total_amount_due varchar(45) NOT NULL, advance_amount_received varchar(45) NOT NULL, advance_date varchar(45) NOT NULL, advance_ref_number varchar(45) NOT NULL, invoice_currency varchar(45) NOT NULL, total_invoice_amount float NOT NULL, invoice_due_date varchar(45) NOT NULL, add_by_id varchar(45) NOT NULL, add_by_datetime datetime NOT NULL, auth_by_id varchar(45) NOT NULL, auth_by_datetime datetime NOT NULL, PRIMARY KEY  (remitter_id));
CREATE TABLE pro_matching ( customer_id varchar(10) NOT NULL, invoice_unique_id decimal(12,0) NOT NULL, statement_unique_id decimal(12,0) NOT NULL, invoice_amount float NOT NULL, statement_amount float NOT NULL, match_by varchar(10) NOT NULL, match_date datetime NOT NULL, auth_by varchar(10) NOT NULL, auth_date datetime NOT NULL, remitter_user varchar(10) NOT NULL, remitter_date datetime NOT NULL, match_type varchar(10) NOT NULL, tolerance_percentage float, tolerance_amount float, discount_percentage float, discount_amount float, penalty_percentage float, penalty_amount float, PRIMARY KEY  (customer_id,invoice_unique_id,statement_unique_id));
INSERT INTO pro_matching (customer_id,invoice_unique_id,statement_unique_id,invoice_amount,statement_amount,match_by,match_date,auth_by,auth_date,remitter_user,remitter_date,match_type,tolerance_percentage,tolerance_amount,discount_percentage,discount_amount,penalty_percentage,penalty_amount) 
VALUES('001','1','3',2044120,1982796.4,'user1','2013-07-21 00:00:00','user1','2013-07-21 00:00:00','user1','2013-07-21 00:00:00','Discount',NULL,NULL,NULL,NULL,NULL,NULL);
CREATE TABLE pro_statement ( statement_unique_id int identity(1,1), customer_id varchar(10) NOT NULL, bank_id varchar(10), statement_date datetime NOT NULL, posting_date datetime NOT NULL, value_date datetime NOT NULL, tran_type varchar(1) NOT NULL, narration1 varchar(50) NOT NULL, narration2 varchar(50), narration3 varchar(50), narration4 varchar(50), amount float NOT NULL, ref_no_or_cheque_no varchar(50) NOT NULL, reconciled_amount float NOT NULL, statement_status char(1) NOT NULL, is_partial tinyint default 1, PRIMARY KEY  (statement_unique_id));
INSERT INTO pro_statement (customer_id,bank_id,statement_date,posting_date,value_date,tran_type,narration1,narration2,narration3,narration4,amount,ref_no_or_cheque_no,reconciled_amount,statement_status,is_partial) 
VALUES('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv1','null','null','null',2044120,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv2','null','null','null',52000,'inv2',52000,'N',0), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','C','payment against inv7','null','null','null',1982796.4,'C312345',0,'M',0), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv4','null','null','null',150000,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv1','null','null','null',2044120,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv2','null','null','null',52000,'inv2',52000,'N',0), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','C','payment against inv7','null','null','null',1982796.4,'C312345',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv4','null','null','null',150000,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv1','null','null','null',2044120,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv2','null','null','null',52000,'inv2',52000,'N',0), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','C','payment against inv7','null','null','null',1982796.4,'C312345',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv4','null','null','null',150000,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv1','null','null','null',2044120,'T00100207052013',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv2','null','null','null',52000,'inv2',52000,'N',0), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','C','payment against inv7','null','null','null',1982796.4,'C312345',0,'N',1), 
('001','B001','2013-07-08 00:00:00','2013-07-08 00:00:00','2013-07-08 00:00:00','N','payment against inv4','null','null','null',150000,'T00100207052013',0,'N',1);
CREATE TABLE pro_statement_dump ( customer_id varchar(10) NOT NULL, file_id int NOT NULL, statement_date datetime NOT NULL, posting_date datetime NOT NULL, value_date datetime NOT NULL, tran_type varchar(1) NOT NULL, narration1 varchar(50) NOT NULL, narration2 varchar(50), narration3 varchar(50), narration4 varchar(50), amount float NOT NULL, ref_no_or_cheque_no varchar(50), PRIMARY KEY  (customer_id));
CREATE TABLE test_pro_file_staging ( Column1 varchar(250) NOT NULL, Column2 varchar(250) NOT NULL, Column3 varchar(250), Column4 varchar(250), Column5 varchar(250), Column6 varchar(250), Column7 varchar(250), Column8 varchar(250), Column9 varchar(250), Column10 varchar(250), Column11 varchar(250), Column12 varchar(250), Column13 varchar(250), Column14 varchar(250), Column15 varchar(250), Column16 varchar(250), Column17 varchar(250), Column18 varchar(250), Column19 varchar(250), Column20 varchar(250), Column21 varchar(250), Column22 varchar(250), Column23 varchar(250), Column24 varchar(250), Column25 varchar(250), Column26 varchar(250), Column27 varchar(250), Column28 varchar(250), Column29 varchar(250), Column30 varchar(250), Column31 varchar(250), Column32 varchar(250), Column33 varchar(250), Column34 varchar(250), Column35 varchar(250), Column36 varchar(250), Column37 varchar(250), Column38 varchar(250), Column39 varchar(250), Column40 varchar(250), Column41 varchar(250), Column42 varchar(250), Column43 varchar(250), Column44 varchar(250), Column45 varchar(250), Column46 varchar(250), Column47 varchar(250), Column48 varchar(250), Column49 varchar(250), Column50 varchar(250), Column51 varchar(250), Column52 varchar(250), Column53 varchar(250), Column54 varchar(250), Column55 varchar(250), Column56 varchar(250), Column57 varchar(250), Column58 varchar(250), Column59 varchar(250), Column60 varchar(250), Column61 varchar(250), Column62 varchar(250), Column63 varchar(250), Column64 varchar(250), Column65 varchar(250), Column66 varchar(250), Column67 varchar(250), Column68 varchar(250), Column69 varchar(250), Column70 varchar(250), Column71 varchar(250), Column72 varchar(250), Column73 varchar(250), Column74 varchar(250), Column75 varchar(250), Column76 varchar(250), Column77 varchar(250), Column78 varchar(250), Column79 varchar(250), Column80 varchar(250), Column81 varchar(250), Column82 varchar(250), Column83 varchar(250), Column84 varchar(250), Column85 varchar(250), Column86 varchar(250), Column87 varchar(250), Column88 varchar(250), Column89 varchar(250), Column90 varchar(250), Column91 varchar(250), Column92 varchar(250), Column93 varchar(250), Column94 varchar(250), Column95 varchar(250), Column96 varchar(250), Column97 varchar(250), Column98 varchar(250), Column99 varchar(250), Column100 varchar(250), Column101 varchar(250));
INSERT INTO test_pro_file_staging (Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10,Column11,Column12,Column13,Column14,Column15,Column16,Column17,Column18,Column19,Column20,Column21,Column22,Column23,Column24,Column25,Column26,Column27,Column28,Column29,Column30,Column31,Column32,Column33,Column34,Column35,Column36,Column37,Column38,Column39,Column40,Column41,Column42,Column43,Column44,Column45,Column46,Column47,Column48,Column49,Column50,Column51,Column52,Column53,Column54,Column55,Column56,Column57,Column58,Column59,Column60,Column61,Column62,Column63,Column64,Column65,Column66,Column67,Column68,Column69,Column70,Column71,Column72,Column73,Column74,Column75,Column76,Column77,Column78,Column79,Column80,Column81,Column82,Column83,Column84,Column85,Column86,Column87,Column88,Column89,Column90,Column91,Column92,Column93,Column94,Column95,Column96,Column97,Column98,Column99,Column100,Column101) 
VALUES('210713112840','R01','001','inv1','2013-07-07','INR','2000000','PR1','20000','4000','120','20000','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112840','R03','001','inv2','2013-07-07','INR','52000','PR2','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112840','R02','001','inv3','2013-07-07','INR','13000000','PR1','13200','1300','130','1300','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112840','R01','001','inv4','2013-07-07','INR','150000','PR1','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112902','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv1','null','null','null','2044120','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112902','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv2','null','null','null','52000','inv2','52000','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112902','001','B001','2013-07-08','2013-07-08','2013-07-08','C','payment against inv7','null','null','null','1982796.40','C312345','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('210713112902','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv4','null','null','null','150000','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222816','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv1','null','null','null','2044120','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222816','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv2','null','null','null','52000','inv2','52000','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222816','001','B001','2013-07-08','2013-07-08','2013-07-08','C','payment against inv7','null','null','null','1982796.40','C312345','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222816','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv4','null','null','null','150000','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222829','R01','001','inv1','2013-07-07','INR','2000000','PR1','20000','4000','120','20000','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222829','R03','001','inv2','2013-07-07','INR','52000','PR2','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222829','R02','001','inv3','2013-07-07','INR','13000000','PR1','13200','1300','130','1300','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222829','R01','001','inv4','2013-07-07','INR','150000','PR1','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222835','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv1','null','null','null','2044120','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222835','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv2','null','null','null','52000','inv2','52000','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222835','001','B001','2013-07-08','2013-07-08','2013-07-08','C','payment against inv7','null','null','null','1982796.40','C312345','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222835','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv4','null','null','null','150000','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222844','R01','001','inv1','2013-07-07','INR','2000000','PR1','20000','4000','120','20000','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222844','R03','001','inv2','2013-07-07','INR','52000','PR2','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222844','R02','001','inv3','2013-07-07','INR','13000000','PR1','13200','1300','130','1300','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713222844','R01','001','inv4','2013-07-07','INR','150000','PR1','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223116','R01','001','inv1','2013-07-07','INR','2000000','PR1','20000','4000','120','20000','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223116','R03','001','inv2','2013-07-07','INR','52000','PR2','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223116','R02','001','inv3','2013-07-07','INR','13000000','PR1','13200','1300','130','1300','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223116','R01','001','inv4','2013-07-07','INR','150000','PR1','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223126','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv1','null','null','null','2044120','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223126','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv2','null','null','null','52000','inv2','52000','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223126','001','B001','2013-07-08','2013-07-08','2013-07-08','C','payment against inv7','null','null','null','1982796.40','C312345','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713223126','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv4','null','null','null','150000','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224028','R01','001','inv1','2013-07-07','INR','2000000','PR1','20000','4000','120','20000','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224028','R03','001','inv2','2013-07-07','INR','52000','PR2','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224028','R02','001','inv3','2013-07-07','INR','13000000','PR1','13200','1300','130','1300','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224028','R01','001','inv4','2013-07-07','INR','150000','PR1','0','0','0','0','0','0','0','0','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224036','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv1','null','null','null','2044120','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224036','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv2','null','null','null','52000','inv2','52000','N','False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224036','001','B001','2013-07-08','2013-07-08','2013-07-08','C','payment against inv7','null','null','null','1982796.40','C312345','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 
('230713224036','001','B001','2013-07-08','2013-07-08','2013-07-08','N','payment against inv4','null','null','null','150000','T00100207052013','0','N','True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
